|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#4
07-03-2020, 02:01 AM
|
|||
|
|||
There is a nak to conditional formatting Highlight the cells you want to change colour on and with the first cell selected do your formula. Before press enter or Oking the box click in the formula and remove the $.
it can be a pain and there are other ways but this does work with a bit of patience 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy colored cells to new worksheet (maintain cell position) | naeemakhtar | Excel Programming | 2 | 06-06-2020 04:02 PM |
| Data Compare and result as true or false in result sheet | aligahk06 | Excel | 1 | 08-29-2019 06:44 AM |
 One Cell that controlls spread sheet result button to change simple fomula result
|
RAH | Excel Programming | 5 | 03-31-2018 04:52 PM |
|
Show result of formula as a value in another cell
|
Steve_D | Excel | 4 | 10-12-2014 07:38 PM |
| Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
Windows 10 
Office 2019
Threaded Mode