SOLVED

Highlights

Copper 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..

Capture.PNG

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 (Copper Contributor)
Solution

@bucharestWine 

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

 

=A1<$G1

 

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!

1 best response

Accepted Solutions
best response confirmed by bucharestWine (Copper Contributor)
Solution

@bucharestWine 

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

 

=A1<$G1

 

The $ before the column letter G is essential.

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

View solution in original post