Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to autofill the condition in conditional formatting in Excel?

Column A has a number 1-10. Column B has a string I want to highlight with conditional formatting. How do I make it so that if the number in Column A is greater than 7, the cell in the same row in Column B will automatically turn blue?

I use the conditional formatting tool for cell B1 such that, in the "Use a formula to determine which cells to format" option, I have ="IF($A1 > 7)", then fill the cell with blue.

But, as I drag/autofill down, the 1 in $A1 does not become A2, A3, A4, A5, A6, etc. as I want it to. What am I doing wrong?

like image 471
phan Avatar asked Mar 22 '23 06:03

phan


1 Answers

Change the formula to:

=$A1 > 7

And take a look at my yoursumbuddy post, which explains why you don't need IFs in Conditional Formatting:

like image 57
Doug Glancy Avatar answered Apr 10 '23 08:04

Doug Glancy