Conditional Formatting

  Desert Andy 15:27 14 Dec 06
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 06

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 06

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

  Whaty 16:05 14 Dec 06

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

New MacBook Pro 2017 release date, UK price and tech specs: Kaby Lake MacBook Pro to launch in…