New Contributor

Hello, I am trying to figure out if the following issue can be done without conditional formatting so i can drag the formula or whatever for all rows..


So this is what I am trying to accomplish: I want to highlight a cell from A1:E1 only if the value inside is smaller than G1 and then paste this formula for A2:E2,G2;A3:E3,G3 and so on given the fact that the dataset is quite big and I have to look for different values in every row and everytime comparing it to different values. THANKS!

2 Replies
best response confirmed by bucharestWine (New Contributor)


That requires conditional formatting, but you need only one rule for the entire range.

Select for example A1:E1000 or even further down.

A1 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula




The $ before the column letter G is essential.

Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.

@Hans Vogelaar 

Thank you so much! it actually worked. only needed to format paint it and that was it!