Previous Topic Next Topic

Copying Conditional Formatting with Formulas Accross Rows

Solved/Closed
Wearrien Posts 1 Registration date Wednesday February 1, 2017 Status Member Last seen February 1, 2017 - Feb 1, 2017 at 03:43 PM
 Wearrien - Feb 2, 2017 at 11:14 AM
Hello,

I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Example: =IF($C7<$M7,$C7>$N7) suppose to be yellow, but when copied to another cell in the row that meets this criteria it doesn't change the color. It works in the initial cell properly.

Any Suggestions

Thanks,
Donna
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Feb 2, 2017 at 10:46 AM
Hi Donna,

That is because you put a dollar symbol in front of the column letter. It will make the column reference absolute, meaning that when you put =$C7 in a cell and drag it to the left/right, it will remain =$C7.

Best regards,
Trowa
Wearrien
Feb 2, 2017 at 11:14 AM
Thanks, that worked

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

26 responses