Conditional Formatting

  Desert Andy 15:27 14 Dec 2006
Locked

If I set a condition format on Cell C3 to go red if it gets to a certain value, is there any way to make the complete row 3 go red as well?

Thanks for your help

  Terry Brown 15:36 14 Dec 2006

Look under IF in excel (I presume you are working in Excel), you should be able to say : if x=true then do this to position x,y
Terry

  VoG II 15:39 14 Dec 2006

Copy the formatting to the whole row using the Format Painter.

  Whaty 16:05 14 Dec 2006

In Conditional Formatting you will need to choose 'Formula Is' and your formula will be something like =$C$3>10 (replace 10 with your value) and you will set the Format to Red. Now you copy the formatting to the whole row using the Format Painter.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?