Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2014, 01:43 AM
teza2k06 teza2k06 is offline Conditional Formatting Formula Windows 7 64bit Conditional Formatting Formula Office 2010 32bit
Advanced Beginner
Conditional Formatting Formula
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default Conditional Formatting Formula

Hopefully a simple one, i need to create a formula with conditional formatting to show the below.

I have 5 different ones to set up, but they will do the same thing

I want to have 4 cells shaded in with colour if 1 cell is blank.

L8 to O8 cells are shaded in if F8 is blank
P8 to S8 cells are shaded in if G8 is blank
T8 to W8 cells are shaded in if H8 is blank
X8 to AA8 cells are shaded in if I8 is blank
X8 to AA8 cells are shaded in if J8 is blank

The formulas will fill in the four cells with colour and then when a cost is entered in the single cell it will change the 4 cells to white

This is something i will hopefully use through the length of the workbook, i have done something like this before, but cant remember what formula i used



Can anyone help?
Reply With Quote
  #2  
Old 08-22-2014, 02:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting Formula Windows 7 64bit Conditional Formatting Formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try =F8=" "
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Formula Dragging conditional formatting like a formula sjp1966 Excel 9 04-13-2017 06:01 AM
Conditional Formatting Formula Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting Formula Formula/Conditional Formatting teza2k06 Excel 1 04-15-2014 06:49 PM
Need formula for search and conditional formatting MikeJedi Excel 9 01-13-2012 12:38 PM
Conditional Formatting Formula conditional formatting formula NEHicks503 Excel 1 11-30-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft