LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default cells automatically colour differently with 'what if' scenario

Of course it will...

Select A1 & B1

CF1: Formula is =($A1="YES")
Format1: Green

CF2: Formula is =($A1="NO")
Format2: Red

In article ,
ben wrote:

conditional formatting won't help the cell adjacent to it though



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to automatically colour cells depending on text? mj_bowen Excel Discussion (Misc queries) 0 January 2nd 10 07:44 PM
Conditional Formatting - Code to colour 3+ text values differently AK9955 Excel Discussion (Misc queries) 3 November 9th 09 06:11 PM
How do I fix cells that print differently than shown? Jade Excel Discussion (Misc queries) 6 August 28th 09 09:02 PM
Link cells in a workbook and be able to sort differently Mex New Users to Excel 1 January 16th 07 01:54 AM
Colour negative border differently Mark Stephens Charts and Charting in Excel 1 August 10th 05 08:44 AM


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"