Hi,
I have the following conditional formats:
=AND($J8>=N$4,$K8<=O$4,$I8=1) - turns cell green
=AND($J8>=N$4,$K8<=O$4,$I8=2) - turns cell red
=AND($J8>=N$4,$K8<=O$4,$I8=0) - turns cell black
but i need to add more so i need to use VBA coding!
Im a beginner at VBA so dont really have an idea of the coding needed!
Also, one point to note - i need these formulas to apply to a whole list of cells i.e. Cell rang L7:BO210 - so quite a lot of cells! And the values in the formulas change for each cell so for cell S13 for instance, the formulas would be:
=AND($J13>=S$4,$K13<=T$4,$I13=1) - again cell green
=AND($J13>=S$4,$K13<=T$4,$I13=2) - cell red
=AND($J13>=S$4,$K13<=T$4,$I3=0) - cell black
Any help would be great, thanks!!
Configuration: Windows XP Internet Explorer 8.0
Hi there,
|
Adding more than three conditional formats in excel Conditional formatting in code vba Conditional formatting in excel to show weekends as red Conditional formatting match text values Conditional formatting to change font color Excel 2003 conditional formatting more than 3 Excel conditional formatting greater than or equal to Excel conditional formatting highlight a row text Format code sony ericsson w705 Format comment excel 2008 If some particular text match in a cell in that case i have to use conditional formatting in excel 2003 If statement in excel with conditional formatting Nokia e75 format code Nokia supernova 7210 format code Samsung format codes of sgh-d900i Thumb drive when it is conditionally formatted Using conditional formatting in excel to highlight a date range Www.nokia 5130 format code.com