Forum Discussion
Solved
Highlights
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!
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.
2 Replies
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.Thank you so much! it actually worked. only needed to format paint it and that was it!
